Node / ReticulumProjects / MeshChatX.git / files / tests / backend / test_message_dao_extended.py

Displaying Raw • Download

T8b949e# SPDX-License-Identifier: 0BSD

Tff7b72import T7ee787json

Tff7b72import T7ee787time

Tff7b72from T7ee787unittestT7ee787.T7ee787mock Tff7b72import Te6edf3MagicMock

Tff7b72import T7ee787pytest

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787database Tff7b72import Te6edf3Database

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787databaseT7ee787.T7ee787messages Tff7b72import Te6edf3MessageDAO

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787databaseT7ee787.T7ee787provider Tff7b72import Te6edf3DatabaseProvider

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787databaseT7ee787.T7ee787schema Tff7b72import Te6edf3DatabaseSchema

Tf0883e@pytestTff7b72.Td2a8fffixture

Tff7b72def Td2a8ffmock_providerTb4b4b4(Tb4b4b4)Tb4b4b4:

Tff7b72return Te6edf3MagicMockTb4b4b4(Tb4b4b4)

Tf0883e@pytestTff7b72.Td2a8fffixture

Tff7b72def Td2a8ffmessage_daoTb4b4b4(Te6edf3mock_providerTb4b4b4)Tb4b4b4:

Tff7b72return Te6edf3MessageDAOTb4b4b4(Te6edf3mock_providerTb4b4b4)

Tf0883e@pytestTff7b72.Td2a8fffixture

Tff7b72def Td2a8ffreal_dbTb4b4b4(Te6edf3tmp_pathTb4b4b4)Tb4b4b4:

Te6edf3db_path Tff7b72= Tffa657strTb4b4b4(Te6edf3tmp_path Tff7b72/ Ta5d6ff"Ta5d6ffmessages.dbTa5d6ff"Tb4b4b4)

Te6edf3provider Tff7b72= Te6edf3DatabaseProviderTb4b4b4(Te6edf3db_pathTb4b4b4)

Te6edf3DatabaseSchemaTb4b4b4(Te6edf3providerTb4b4b4)Tff7b72.Td2a8ffinitializeTb4b4b4(Tb4b4b4)

Tff7b72return Te6edf3DatabaseTb4b4b4(Te6edf3db_pathTb4b4b4)

Tff7b72def Td2a8ff_insert_messageTb4b4b4(Te6edf3dbTb4b4b4, Te6edf3hash_hexTb4b4b4, Tff7b72*Tb4b4b4, Te6edf3is_incomingTb4b4b4, Te6edf3stateTb4b4b4, Te6edf3methodTff7b72=Ta5d6ff"Ta5d6ffdirectTa5d6ff"Tb4b4b4)Tb4b4b4:

Te6edf3peer Tff7b72= Ta5d6ff"Ta5d6ffbTa5d6ff" Tff7b72* T79c0ff32

Te6edf3dbTff7b72.Td2a8ffmessagesTff7b72.Td2a8ffupsert_lxmf_messageTb4b4b4(

Tb4b4b4{

Ta5d6ff"Ta5d6ffhashTa5d6ff"Tb4b4b4: Te6edf3hash_hexTb4b4b4,

Ta5d6ff"Ta5d6ffsource_hashTa5d6ff"Tb4b4b4: Te6edf3peerTb4b4b4,

Ta5d6ff"Ta5d6ffdestination_hashTa5d6ff"Tb4b4b4: Te6edf3peerTb4b4b4,

Ta5d6ff"Ta5d6ffpeer_hashTa5d6ff"Tb4b4b4: Te6edf3peerTb4b4b4,

Ta5d6ff"Ta5d6ffstateTa5d6ff"Tb4b4b4: Te6edf3stateTb4b4b4,

Ta5d6ff"Ta5d6ffprogressTa5d6ff"Tb4b4b4: T79c0ff0.0Tb4b4b4,

Ta5d6ff"Ta5d6ffis_incomingTa5d6ff"Tb4b4b4: Te6edf3is_incomingTb4b4b4,

Ta5d6ff"Ta5d6ffmethodTa5d6ff"Tb4b4b4: Te6edf3methodTb4b4b4,

Ta5d6ff"Ta5d6ffdelivery_attemptsTa5d6ff"Tb4b4b4: T79c0ff0Tb4b4b4,

Ta5d6ff"Ta5d6ffnext_delivery_attempt_atTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4,

Ta5d6ff"Ta5d6fftitleTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6fftTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffcontentTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffcTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6fffieldsTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4,

Ta5d6ff"Ta5d6fftimestampTa5d6ff"Tb4b4b4: Te6edf3timeTff7b72.Td2a8fftimeTb4b4b4(Tb4b4b4)Tb4b4b4,

Ta5d6ff"Ta5d6ffrssiTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4,

Ta5d6ff"Ta5d6ffsnrTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4,

Ta5d6ff"Ta5d6ffqualityTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4,

Ta5d6ff"Ta5d6ffis_spamTa5d6ff"Tb4b4b4: T79c0ff0Tb4b4b4,

Ta5d6ff"Ta5d6ffreply_to_hashTa5d6ff"Tb4b4b4: Tff7b72NoneTb4b4b4,

Ta5d6ff"Ta5d6ffattachments_strippedTa5d6ff"Tb4b4b4: T79c0ff0Tb4b4b4,

Tb4b4b4}Tb4b4b4,

Tb4b4b4)

Tff7b72def Td2a8fftest_mark_stuck_messages_never_fails_incoming_messagesTb4b4b4(Te6edf3real_dbTb4b4b4)Tb4b4b4:

T8b949e# Incoming messages are stored with the default "generating" state and must

T8b949e# never be flagged as failed by the stuck-message sweep.

Te6edf3_insert_messageTb4b4b4(Te6edf3real_dbTb4b4b4, Ta5d6ff"Ta5d6ffaTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4, Te6edf3is_incomingTff7b72=T79c0ff1Tb4b4b4, Te6edf3stateTff7b72=Ta5d6ff"Ta5d6ffgeneratingTa5d6ff"Tb4b4b4)

T8b949e# Outbound messages stuck mid-send should be failed.

Te6edf3_insert_messageTb4b4b4(Te6edf3real_dbTb4b4b4, Ta5d6ff"Ta5d6ffcTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4, Te6edf3is_incomingTff7b72=T79c0ff0Tb4b4b4, Te6edf3stateTff7b72=Ta5d6ff"Ta5d6ffgeneratingTa5d6ff"Tb4b4b4)

Te6edf3_insert_messageTb4b4b4(Te6edf3real_dbTb4b4b4, Ta5d6ff"Ta5d6ffdTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4, Te6edf3is_incomingTff7b72=T79c0ff0Tb4b4b4, Te6edf3stateTff7b72=Ta5d6ff"Ta5d6ffsendingTa5d6ff"Tb4b4b4)

Te6edf3_insert_messageTb4b4b4(Te6edf3real_dbTb4b4b4, Ta5d6ff"Ta5d6ffeTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4, Te6edf3is_incomingTff7b72=T79c0ff0Tb4b4b4, Te6edf3stateTff7b72=Ta5d6ff"Ta5d6ffdeliveredTa5d6ff"Tb4b4b4)

Te6edf3real_dbTff7b72.Td2a8ffmessagesTff7b72.Td2a8ffmark_stuck_messages_as_failedTb4b4b4(Tb4b4b4)

Tff7b72assert Te6edf3real_dbTff7b72.Td2a8ffmessagesTff7b72.Td2a8ffget_lxmf_message_by_hashTb4b4b4(Ta5d6ff"Ta5d6ffaTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4)Tb4b4b4[Ta5d6ff"Ta5d6ffstateTa5d6ff"Tb4b4b4] Tff7b72== Ta5d6ff"Ta5d6ffgeneratingTa5d6ff"

Tff7b72assert Te6edf3real_dbTff7b72.Td2a8ffmessagesTff7b72.Td2a8ffget_lxmf_message_by_hashTb4b4b4(Ta5d6ff"Ta5d6ffcTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4)Tb4b4b4[Ta5d6ff"Ta5d6ffstateTa5d6ff"Tb4b4b4] Tff7b72== Ta5d6ff"Ta5d6fffailedTa5d6ff"

Tff7b72assert Te6edf3real_dbTff7b72.Td2a8ffmessagesTff7b72.Td2a8ffget_lxmf_message_by_hashTb4b4b4(Ta5d6ff"Ta5d6ffdTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4)Tb4b4b4[Ta5d6ff"Ta5d6ffstateTa5d6ff"Tb4b4b4] Tff7b72== Ta5d6ff"Ta5d6fffailedTa5d6ff"

Tff7b72assert Te6edf3real_dbTff7b72.Td2a8ffmessagesTff7b72.Td2a8ffget_lxmf_message_by_hashTb4b4b4(Ta5d6ff"Ta5d6ffeTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4)Tb4b4b4[Ta5d6ff"Ta5d6ffstateTa5d6ff"Tb4b4b4] Tff7b72== Ta5d6ff"Ta5d6ffdeliveredTa5d6ff"

Tff7b72def Td2a8fftest_mark_stuck_messages_repairs_previously_failed_incomingTb4b4b4(Te6edf3real_dbTb4b4b4)Tb4b4b4:

T8b949e# Simulate a database corrupted by the previous buggy sweep that flipped

T8b949e# received messages to "failed".

Te6edf3_insert_messageTb4b4b4(Te6edf3real_dbTb4b4b4, Ta5d6ff"Ta5d6ffaTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4, Te6edf3is_incomingTff7b72=T79c0ff1Tb4b4b4, Te6edf3stateTff7b72=Ta5d6ff"Ta5d6fffailedTa5d6ff"Tb4b4b4)

Te6edf3real_dbTff7b72.Td2a8ffmessagesTff7b72.Td2a8ffmark_stuck_messages_as_failedTb4b4b4(Tb4b4b4)

Tff7b72assert Te6edf3real_dbTff7b72.Td2a8ffmessagesTff7b72.Td2a8ffget_lxmf_message_by_hashTb4b4b4(Ta5d6ff"Ta5d6ffaTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4)Tb4b4b4[Ta5d6ff"Ta5d6ffstateTa5d6ff"Tb4b4b4] Tff7b72== Ta5d6ff"Ta5d6ffgeneratingTa5d6ff"

Tff7b72def Td2a8fftest_normalize_lxmf_message_for_import_strips_export_metadataTb4b4b4(Tb4b4b4)Tb4b4b4:

Te6edf3row Tff7b72= Tb4b4b4{

Ta5d6ff"Ta5d6ffidTa5d6ff"Tb4b4b4: T79c0ff1Tb4b4b4,

Ta5d6ff"Ta5d6ffhashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffaTa5d6ff" Tff7b72* T79c0ff64Tb4b4b4,

Ta5d6ff"Ta5d6ffsource_hashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffbTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4,

Ta5d6ff"Ta5d6ffdestination_hashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffcTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4,

Ta5d6ff"Ta5d6ffstateTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffgeneratingTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffis_incomingTa5d6ff"Tb4b4b4: T79c0ff1Tb4b4b4,

Ta5d6ff"Ta5d6fffieldsTa5d6ff"Tb4b4b4: Ta5d6ff"Tffd700{}Ta5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffcreated_atTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ff2026-05-09T01:12:37.063720+00:00Ta5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6fflxmf_iconTa5d6ff"Tb4b4b4: Tb4b4b4{Ta5d6ff"Ta5d6fficon_nameTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffaccountTa5d6ff"Tb4b4b4}Tb4b4b4,

Tb4b4b4}

Te6edf3normalized Tff7b72= Te6edf3MessageDAOTff7b72.Td2a8ffnormalize_lxmf_message_for_importTb4b4b4(Te6edf3rowTb4b4b4)

Tff7b72assert Te6edf3normalized Tff7b72is Tff7b72not Tff7b72None

Tff7b72assert Te6edf3normalizedTb4b4b4[Ta5d6ff"Ta5d6ffpeer_hashTa5d6ff"Tb4b4b4] Tff7b72== Ta5d6ff"Ta5d6ffbTa5d6ff" Tff7b72* T79c0ff32

Tff7b72assert Ta5d6ff"Ta5d6ffidTa5d6ff" Tff7b72not Tff7b72in Te6edf3normalized

Tff7b72assert Ta5d6ff"Ta5d6fflxmf_iconTa5d6ff" Tff7b72not Tff7b72in Te6edf3normalized

Tff7b72def Td2a8fftest_import_lxmf_messages_skips_invalid_rowsTb4b4b4(Te6edf3real_dbTb4b4b4)Tb4b4b4:

Te6edf3messages Tff7b72= Tb4b4b4[

Tb4b4b4{Ta5d6ff"Ta5d6ffhashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffaTa5d6ff" Tff7b72* T79c0ff64Tb4b4b4, Ta5d6ff"Ta5d6ffsource_hashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffbTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4, Ta5d6ff"Ta5d6ffdestination_hashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffcTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4}Tb4b4b4,

Tb4b4b4{Ta5d6ff"Ta5d6ffhashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6ffsource_hashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffbTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4, Ta5d6ff"Ta5d6ffdestination_hashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffcTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4}Tb4b4b4,

Tb4b4b4]

Te6edf3result Tff7b72= Te6edf3real_dbTff7b72.Td2a8ffmessagesTff7b72.Td2a8ffimport_lxmf_messagesTb4b4b4(Te6edf3messagesTb4b4b4)

Tff7b72assert Te6edf3resultTb4b4b4[Ta5d6ff"Ta5d6ffimportedTa5d6ff"Tb4b4b4] Tff7b72== T79c0ff1

Tff7b72assert Te6edf3resultTb4b4b4[Ta5d6ff"Ta5d6ffskippedTa5d6ff"Tb4b4b4] Tff7b72== T79c0ff1

Tff7b72assert Te6edf3resultTb4b4b4[Ta5d6ff"Ta5d6fferrorsTa5d6ff"Tb4b4b4] Tff7b72== Tb4b4b4[Tb4b4b4]

Tff7b72def Td2a8fftest_import_lxmf_messages_without_attachments_stripped_columnTb4b4b4(Te6edf3tmp_pathTb4b4b4)Tb4b4b4:

Te6edf3db_path Tff7b72= Tffa657strTb4b4b4(Te6edf3tmp_path Tff7b72/ Ta5d6ff"Ta5d6fflegacy.dbTa5d6ff"Tb4b4b4)

Te6edf3provider Tff7b72= Te6edf3DatabaseProviderTb4b4b4(Te6edf3db_pathTb4b4b4)

Te6edf3DatabaseSchemaTb4b4b4(Te6edf3providerTb4b4b4)Tff7b72.Td2a8ffinitializeTb4b4b4(Tb4b4b4)

Te6edf3providerTff7b72.Td2a8ffexecuteTb4b4b4(Ta5d6ff"Ta5d6ffALTER TABLE lxmf_messages DROP COLUMN attachments_strippedTa5d6ff"Tb4b4b4)

Te6edf3db Tff7b72= Te6edf3DatabaseTb4b4b4(Te6edf3db_pathTb4b4b4)

Te6edf3result Tff7b72= Te6edf3dbTff7b72.Td2a8ffmessagesTff7b72.Td2a8ffimport_lxmf_messagesTb4b4b4(

Tb4b4b4[

Tb4b4b4{

Ta5d6ff"Ta5d6ffidTa5d6ff"Tb4b4b4: T79c0ff1Tb4b4b4,

Ta5d6ff"Ta5d6ffhashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffaTa5d6ff" Tff7b72* T79c0ff64Tb4b4b4,

Ta5d6ff"Ta5d6ffsource_hashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffbTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4,

Ta5d6ff"Ta5d6ffdestination_hashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffcTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4,

Ta5d6ff"Ta5d6ffpeer_hashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffbTa5d6ff" Tff7b72* T79c0ff32Tb4b4b4,

Ta5d6ff"Ta5d6ffstateTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffgeneratingTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffprogressTa5d6ff"Tb4b4b4: T79c0ff0Tb4b4b4,

Ta5d6ff"Ta5d6ffis_incomingTa5d6ff"Tb4b4b4: T79c0ff1Tb4b4b4,

Ta5d6ff"Ta5d6ffmethodTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffopportunisticTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6fffieldsTa5d6ff"Tb4b4b4: Ta5d6ff"Tffd700{}Ta5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6fftimestampTa5d6ff"Tb4b4b4: T79c0ff1773512977.322906Tb4b4b4,

Ta5d6ff"Ta5d6ffattachments_strippedTa5d6ff"Tb4b4b4: T79c0ff0Tb4b4b4,

Tb4b4b4}Tb4b4b4,

Tb4b4b4]Tb4b4b4,

Tb4b4b4)

Tff7b72assert Te6edf3resultTb4b4b4[Ta5d6ff"Ta5d6ffimportedTa5d6ff"Tb4b4b4] Tff7b72== T79c0ff1

Tff7b72assert Te6edf3resultTb4b4b4[Ta5d6ff"Ta5d6fferrorsTa5d6ff"Tb4b4b4] Tff7b72== Tb4b4b4[Tb4b4b4]

Tff7b72def Td2a8fftest_upsert_lxmf_messageTb4b4b4(Te6edf3message_daoTb4b4b4, Te6edf3mock_providerTb4b4b4)Tb4b4b4:

Te6edf3mock_providerTff7b72.Td2a8fffetchallTff7b72.Td2a8ffreturn_value Tff7b72= Tb4b4b4[

Tb4b4b4{Ta5d6ff"Ta5d6ffnameTa5d6ff"Tb4b4b4: Te6edf3fieldTb4b4b4}

Tff7b72for Te6edf3field Tff7b72in Tb4b4b4(

Ta5d6ff"Ta5d6ffhashTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffsource_hashTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffdestination_hashTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffpeer_hashTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffstateTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffprogressTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffis_incomingTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffmethodTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffdelivery_attemptsTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffnext_delivery_attempt_atTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6fftitleTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffcontentTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6fffieldsTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6fftimestampTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffrssiTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffsnrTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffqualityTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffis_spamTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffreply_to_hashTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffattachments_strippedTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffpath_hops_at_sendTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffpath_interface_at_sendTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffpath_finding_measureTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffpath_row_hash_hexTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffcreated_atTa5d6ff"Tb4b4b4,

Ta5d6ff"Ta5d6ffupdated_atTa5d6ff"Tb4b4b4,

Tb4b4b4)

Tb4b4b4]

Te6edf3data Tff7b72= Tb4b4b4{Ta5d6ff"Ta5d6ffhashTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffhash1Ta5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6ffcontentTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffhelloTa5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6fffieldsTa5d6ff"Tb4b4b4: Tb4b4b4{Ta5d6ff"Ta5d6ffkeyTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffvalTa5d6ff"Tb4b4b4}Tb4b4b4}

Te6edf3message_daoTff7b72.Td2a8ffupsert_lxmf_messageTb4b4b4(Te6edf3dataTb4b4b4)

Te6edf3argsTb4b4b4, Te6edf3_ Tff7b72= Te6edf3mock_providerTff7b72.Td2a8ffexecuteTff7b72.Td2a8ffcall_args

Te6edf3queryTb4b4b4, Te6edf3params Tff7b72= Te6edf3args

Tff7b72assert Ta5d6ff"Ta5d6ffINSERT INTO lxmf_messagesTa5d6ff" Tff7b72in Te6edf3query

Tff7b72assert Ta5d6ff"Ta5d6ffhash1Ta5d6ff" Tff7b72in Te6edf3params

Tff7b72assert Ta5d6ff"Ta5d6ffhelloTa5d6ff" Tff7b72in Te6edf3params

Tff7b72assert Te6edf3jsonTff7b72.Td2a8ffdumpsTb4b4b4(Tb4b4b4{Ta5d6ff"Ta5d6ffkeyTa5d6ff"Tb4b4b4: Ta5d6ff"Ta5d6ffvalTa5d6ff"Tb4b4b4}Tb4b4b4) Tff7b72in Te6edf3params

Tff7b72def Td2a8fftest_get_lxmf_message_by_hashTb4b4b4(Te6edf3message_daoTb4b4b4, Te6edf3mock_providerTb4b4b4)Tb4b4b4:

Te6edf3message_daoTff7b72.Td2a8ffget_lxmf_message_by_hashTb4b4b4(Ta5d6ff"Ta5d6ffhash1Ta5d6ff"Tb4b4b4)

Te6edf3mock_providerTff7b72.Td2a8fffetchoneTff7b72.Td2a8ffassert_called_withTb4b4b4(

Ta5d6ff"Ta5d6ffSELECT * FROM lxmf_messages WHERE hash = ?Ta5d6ff"Tb4b4b4,

Tb4b4b4(Ta5d6ff"Ta5d6ffhash1Ta5d6ff"Tb4b4b4,Tb4b4b4)Tb4b4b4,

Tb4b4b4)

Tff7b72def Td2a8fftest_delete_lxmf_messages_by_hashesTb4b4b4(Te6edf3message_daoTb4b4b4, Te6edf3mock_providerTb4b4b4)Tb4b4b4:

Te6edf3message_daoTff7b72.Td2a8ffdelete_lxmf_messages_by_hashesTb4b4b4(Tb4b4b4[Ta5d6ff"Ta5d6ffh1Ta5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6ffh2Ta5d6ff"Tb4b4b4]Tb4b4b4)

Te6edf3argsTb4b4b4, Te6edf3_ Tff7b72= Te6edf3mock_providerTff7b72.Td2a8ffexecuteTff7b72.Td2a8ffcall_args

Tff7b72assert Ta5d6ff"Ta5d6ffDELETE FROM lxmf_messages WHERE hash IN (?, ?)Ta5d6ff" Tff7b72in Te6edf3argsTb4b4b4[T79c0ff0Tb4b4b4]

Tff7b72assert Te6edf3argsTb4b4b4[T79c0ff1Tb4b4b4] Tff7b72== Tb4b4b4(Ta5d6ff"Ta5d6ffh1Ta5d6ff"Tb4b4b4, Ta5d6ff"Ta5d6ffh2Ta5d6ff"Tb4b4b4)

Tff7b72def Td2a8fftest_delete_all_lxmf_messagesTb4b4b4(Te6edf3message_daoTb4b4b4, Te6edf3mock_providerTb4b4b4)Tb4b4b4:

Te6edf3message_daoTff7b72.Td2a8ffdelete_all_lxmf_messagesTb4b4b4(Tb4b4b4)

Tff7b72assert Te6edf3mock_providerTff7b72.Td2a8ffexecuteTff7b72.Td2a8ffcall_count Tff7b72== T79c0ff2

Tff7b72def Td2a8fftest_get_conversation_messagesTb4b4b4(Te6edf3message_daoTb4b4b4, Te6edf3mock_providerTb4b4b4)Tb4b4b4:

Te6edf3message_daoTff7b72.Td2a8ffget_conversation_messagesTb4b4b4(Ta5d6ff"Ta5d6ffpeer1Ta5d6ff"Tb4b4b4, Te6edf3limitTff7b72=T79c0ff10Tb4b4b4, Te6edf3offsetTff7b72=T79c0ff5Tb4b4b4)

Te6edf3mock_providerTff7b72.Td2a8fffetchallTff7b72.Td2a8ffassert_called_withTb4b4b4(

Ta5d6ff"Ta5d6ffSELECT * FROM lxmf_messages WHERE peer_hash = ? ORDER BY timestamp DESC LIMIT ? OFFSET ?Ta5d6ff"Tb4b4b4,

Tb4b4b4(Ta5d6ff"Ta5d6ffpeer1Ta5d6ff"Tb4b4b4, T79c0ff10Tb4b4b4, T79c0ff5Tb4b4b4)Tb4b4b4,

Tb4b4b4)

Tff7b72def Td2a8fftest_set_lxmf_message_path_at_send_if_unsetTb4b4b4(Te6edf3message_daoTb4b4b4, Te6edf3mock_providerTb4b4b4)Tb4b4b4:

Te6edf3message_daoTff7b72.Td2a8ffset_lxmf_message_path_at_send_if_unsetTb4b4b4(Ta5d6ff"Ta5d6ffdeadbeefTa5d6ff"Tb4b4b4, T79c0ff2Tb4b4b4, Ta5d6ff"Ta5d6ffUDP InterfaceTa5d6ff"Tb4b4b4)

Te6edf3argsTb4b4b4, Te6edf3_ Tff7b72= Te6edf3mock_providerTff7b72.Td2a8ffexecuteTff7b72.Td2a8ffcall_args

Te6edf3queryTb4b4b4, Te6edf3params Tff7b72= Te6edf3args

Tff7b72assert Ta5d6ff"Ta5d6ffpath_hops_at_sendTa5d6ff" Tff7b72in Te6edf3query

Tff7b72assert Ta5d6ff"Ta5d6ffpath_hops_at_send IS NULLTa5d6ff" Tff7b72in Te6edf3query

Tff7b72assert Te6edf3paramsTb4b4b4[T79c0ff0Tb4b4b4] Tff7b72== T79c0ff2

Tff7b72assert Te6edf3paramsTb4b4b4[T79c0ff1Tb4b4b4] Tff7b72== Ta5d6ff"Ta5d6ffUDP InterfaceTa5d6ff"

Tff7b72assert Te6edf3paramsTb4b4b4[T79c0ff3Tb4b4b4] Tff7b72== Ta5d6ff"Ta5d6ffdeadbeefTa5d6ff"